Enable sa Account Login
Login into SQL Server with Windows Authentication mode
Start SQL Server Management Studio, choose Windows Authentication mode, and click Connect button.
Change SQL Server properties
Right-click Server in Object Explorer, and go to Properties. In Server Properties window, select Security, and choose SQL Server and Windows Authentication Mode. Then click OK to save changes.
Enable sa Account
In Object Explorer, navigate to Security > Logins > sa. Right-click sa account, and go to Properties. In Login Properties window, set password for sa account and confirm it. Then select Status, choose Grant for Permission to connecto to database engine, and choose Enabled for *login. Then click OK to save changes.
Restart SQL Server Services
Generate Dataset
Compile the dbgen.exe
Go to the dbgen folder, open the tpch.sln and Build in Visual Studio. The dbgen.exe will be created under the Debug folder. Then copy the dists.dss to the Debug folder.
Generate Dataset
Go to the debgen/Debug folder, run the dbgen.exe to generate 1GB of dataset. The dataset is separated in 8 .tbl files in the Debug folder, one for each of the TPC-H tables.